www.gusucode.com > WSTMall PHP网店系统 v1.6.0PHP源码程序 > WSTMall PHP网店系统 v1.6.0/wstmall_v1.6.0_160506/wstmall_v1.6.0_160506/Apps/Home/Model/FavoritesModel.class.php
<?php namespace Home\Model; /** * ============================================================================ * WSTMall开源商城 * 官网地址:http://www.wstmall.com * 联系QQ:707563272 * ============================================================================ * 关注商品/店铺服务类 */ class FavoritesModel extends BaseModel { /** * 关注商品 */ public function favoriteGoods(){ $rd = array('status'=>-1); $id = (int)I('id'); //检测商品是否存在 $sql = "select goodsId from __PREFIX__goods where goodsFlag=1 and isSale=1 and goodsStatus=1 and goodsId=".$id; $rs = $this->query($sql); if(!empty($sql)){ $data = array(); $data['userId'] = (int)session('WST_USER.userId'); $data['favoriteType'] = 0; $data['targetId'] = $id; $data['createTime'] = date('Y-m-d H:i:s'); if($this->checkEmpty($data)){ $rs = $this->add($data); if(false !== $rs){ $rd['status']= 1; $rd['id']= $rs; } } } return $rd; } /** * 关注店铺 */ public function favoriteShops(){ $rd = array('status'=>-1); $id = (int)I('id'); //检测商品是否存在 $sql = "select shopId from __PREFIX__shops where shopFlag=1 and shopStatus=1 and shopId=".$id; $rs = $this->query($sql); if(!empty($sql)){ $data = array(); $data['userId'] = (int)session('WST_USER.userId'); $data['favoriteType'] = 1; $data['targetId'] = $id; $data['createTime'] = date('Y-m-d H:i:s'); if($this->checkEmpty($data)){ $rs = $this->add($data); if(false !== $rs){ $rd['status']= 1; $rd['id']= $rs; } } } return $rd; } /** * 判断是否已关注 */ public function checkFavorite($id,$type){ //检测商品是否存在 $sql = "select favoriteId from __PREFIX__favorites where favoriteType=".$type." and targetId=".$id." and userId=".(int)session('WST_USER.userId'); $rs = $this->queryRow($sql); return empty($rs)?0:$rs['favoriteId']; } /** * 取消关注 */ public function cancelFavorite(){ $rd = array('status'=>-1); $id = (int)I('id'); $type = (int)I('type'); $rs = $this->where('favoriteType='.$type." and favoriteId=".$id." and userId=".(int)session('WST_USER.userId'))->delete(); if(false !== $rs){ $rd['status']= 1; } return $rd; } /** * 获取关注列表 */ public function queryGoodsByPage(){ $key = WSTAddslashes(I('key')); $sql = "select f.favoriteId,g.goodsId,g.goodsThums,g.goodsName,g.isSale,g.shopPrice,g.saleCount,ga.id goodsAttrId from __PREFIX__favorites f ,__PREFIX__goods g left join __PREFIX__goods_attributes ga on g.goodsId=ga.goodsId and ga.isRecomm=1 where f.targetId = g.goodsId and g.goodsStatus=1 and g.goodsFlag=1 and favoriteType=0 and userId=".(int)session('WST_USER.userId'); if($key!='')$sql.=" and g.goodsName like '%".$key."%'"; $sql.=" order by f.favoriteId desc"; return $this->pageQuery($sql); } /** * 获取关注列表 */ public function queryShopsByPage(){ $key = WSTAddslashes(I('key')); $sql = "select f.favoriteId,p.shopId,p.shopName,p.shopImg from __PREFIX__favorites f ,__PREFIX__shops p where f.targetId = p.shopId and p.shopStatus=1 and p.shopFlag=1 and favoriteType=1 and f.userId=".(int)session('WST_USER.userId'); if($key!='')$sql.=" and p.shopName like '%".$key."%'"; $sql.=" order by f.favoriteId desc"; return $this->pageQuery($sql); } }